System administrators can execute custom SQL scripts by first setting up report specifications. The benefit of executing a SQL script in this method is that the script can be automated from the iMIS front-end and report driven.
Note: Place your cursor in the Parameters box and press CTRL+Z or click the
button to open the parameters window.Example: Select a Report from the SYSTEM-System Setup.
Example: Enter MUST_BE_DBO,SHOW_SQL in the Options box.
Example: Substitute the script in the Parameters box.
Example: You can now execute the script.
10.6 Production Release. Updated 3/8/2006 11:35:45 AM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.